EFS Financial Dashboard

Total Revenue

SAR 642.0M

YTD • 642,003,658 SAR

📈

Net Profit YTD

SAR 46.7M

46,727,086 SAR

🎯

Gross Margin

14.2%

GP: SAR 91.2M

Current Ratio

1.51x

CA / CL Liquidity

🚀

Total Assets

SAR 850.3M

850,277,538 SAR

🏛️

Oper. Cash Flow

SAR 66.3M

66,330,206 SAR

💎

SAR 73.9M Revenue & Expenses SAR 71.6M

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

Revenue Sources

Contractual vs Variation

Capital Allocation

Performance Levers

Region Sources 73.9M

Vertical Performance (Rev vs GP)

Rev SAR 146.5M • GP SAR 16.0M

Margin Velocity

Net: SAR 2.3M

Financial Value Flywheel 10.3% GM

🔄 Operating Cycle Conversion Net Profit: SAR 2.3M (3.1%)

Top Projects (Revenue vs Net Profit) Top 6 Projects

Cash Flow & Profit Comparison Jan 2025

🏛️ BS Category Composition SAR 531.2M

💎 Asset Structure Breakdown CA + NCA

⚖️ Liabilities & Equity Mix CL + NCL + EQ

📊 Liquidity & Solvency Ratios (%)

🌉 Working Capital & Equity Bridge

📈 Monthly Balance Sheet Trends (Jan–Dec)

🔍 Balance Sheet Positions Dec Balance = cumulative year-end closing balance

Account Code	Description	Category	cat2_raw	Sub-Category	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Dec Balance

Filtered Total (Dec Balance): — SAR · updates with search & filter

📈 Total Revenue

SAR 73.9M

▲ Jan 2025

📆 Gross Profit

SAR 7.6M

GM: 10.3%

⚡ EBITDA

SAR 3.8M

Operating Income

✅ Net Profit

SAR 2.3M

After All Costs

📈

73.9M

Revenue

📆

7.6M

Gross Profit

⚡

3.8M

EBITDA

✅

2.3M

Net Profit

📊

10.3%

Gross Margin

🎯

1.40x

Current Ratio

Revenue vs Profit

📋 Cost Lines – Full Year

📋 P&L Statement – 3-Level Hierarchical View Level 1: Category ▸ Sub-Category ▸ Description | Click header to expand

📈 Gross Profit Margin Profitability

10.3%

Gross Profit: SAR 7.6M Benchmark: 15.0%

⚡ EBITDA Margin Operations

7.9%

EBITDA: SAR 3.8M Benchmark: 8.0%

💰 Net Profit Margin Net Return

6.7%

Net Profit: SAR 2.3M Benchmark: 6.0%

⚖ Cost-to-Income Efficiency

93.3%

Total Costs: SAR 857.5M Benchmark: < 94%

🛠 Direct Cost Ratio Cost Structure

51.0%

Direct Costs: SAR 469.0M % of Revenue

👥 Manpower Cost Ratio Labor

29.1%

Manpower Total: SAR 267.8M COR + SGA

📋 G&A Expense Ratio Overhead

5.6%

G&A + SGA: SAR 51.5M % of Revenue

📊 Operating Margin EBIT

7.9%

Operating Income: SAR 3.8M Before Finance/Tax

🎯 Executive Budget vs Actual & Variance Studio

Consolidated Financial Control • Board Approved FY 2025 Budget vs 3,342 Actual TB Line Items

Column Header	Required	Example Values
Category	Required	REVENUE, Direct Costs, MANPOWER COST - COR, G&A, etc.
Sub_Category	Optional	Housekeeping, Security, Overhead, Engineering
Sector / Region	Optional	Commercial, Residential, Western, Central
Jan .. Dec (or Total_Budget)	Required	Numeric values in SAR (e.g. 12500000 or 150000000)

Target Revenue Budget

SAR 950.0M

Jan 2025 Target

Actual Revenue 96.8%

SAR 73.9M

▼ -SAR 30.6M (-3.2%)

Target Gross Profit Budget

SAR 135.0M

Budget GM: 14.2%

Actual Gross Profit 92.0%

SAR 7.6M

▼ -SAR 10.8M (GM 10.3%)

Target Net Profit Budget

SAR 75.0M

Budget Net: 7.9%

Actual Net Profit 82.5%

SAR 2.3M

▼ -SAR 13.1M (Net 6.7%)

Executive Profit Variance Bridge (Budget Target ➔ Actual Net Profit)

SAR Millions • Step Analysis

Target Achievement Gauges

% Realized

Monthly Revenue Trajectory vs Budget Target Corridor

2025 Actual vs Target vs 2024 Base

Sector Realization: Actual vs Budget

SAR Millions

📋 Master Budget vs Actual Financial Statement • 3-Level Hierarchy

Financial Line Item	Actual 2025 (SAR)	Budget 2025 (SAR)	Variance (SAR)	Variance % & Spread	Prior Year 2024 (SAR)	YoY Growth	Target Status

📷 Hover over any chart → click ⇓ icon (top-right) to save as PNG / SVG / CSV

Monthly Cash Flow Components

Cumulative Net Cash Flow

💲 Indirect Cash Flow Statement – Monthly (Jan–Dec 2025)

Month	Net Profit	Operating CF (Net+D&A)	Investing CF (−ΔNCA)	Financing CF (ΔNCL+Equity)	Net Cash Flow

Master Chart of Accounts Uploader

Upload your latest Master File. The database holds all accounts, adds new codes, and safely ignores existing duplicates.

💾 Stored in: dim_accounts

📘

📁Choose / Browse Master File

✨ Click "Choose / Browse Master File" above or drag & drop Master_file.xlsx / .csv anywhere here

Monthly Transaction File Uploader (TB - TRA)

Upload your monthly TB report (e.g. 125 - JAN 25.csv). The system matches every ledger code against Master and alerts you if new unmapped accounts exist.

⚡ Auto-Validation Engine

📊

📁Choose / Browse Transaction File

✨ Click "Choose / Browse Transaction File" above or drag & drop 125 - JAN 25.csv anywhere here

Period Management & Monthly Purge

Delete specific months & years from the SQLite database. Useful when re-running a month or clearing test data.

Period Key	Month & Year	Transactions	Net Sum	Action
Loading periods from SQLite3...

📥Download Mapped Trial Balance & Financial Statements

Export 100% mapped account codes, descriptions, categories, and financial statements directly into formatted Excel (.xlsx).

⚡ Live SQLite3 Engine

📅

1. Month + Year

Single-month Trial Balance showing beginning balance, that month's postings, YTD, and ending balance.

⏳

2. As on Month + Year

Cumulative cut-off position as on selected month end (Beg Bal + Cumulative YTD = Closing Bal).

📊

3. Yearly (Full Year Matrix)

Annual consolidated matrix showing all 12 monthly columns, total annual postings, and final balance.

Select Year

Select Month

Export Action

Selected Target March 2025 (Month TB)

Mapped Accounts 1,901 Accounts

Total Debits SAR 176,596,977

Total Credits SAR -176,036,491

✅ 100% Balanced

Quick 1-Click Downloads:

Account No.	Debit (SAR)	Credit (SAR)	Account Description	Doc Number	Type	Date
Loading ledger records...
Subtotal	0.00	0.00	✅ Balanced